create database TestDB
on
(
	name='TestDB',
	size=6MB,
	filegrowth=1MB,
	maxsize=200MB,
	filename='E:\DATA\TestDB.mdf'
)

log on
(
	name='TestDB_log',
	size=6MB,
	filegrowth=1MB,
	maxsize=200MB,
	filename='E:\DATA\TestDB_log.ldf'
)
use TestDB
go
drop database TestDB

create database company
on
(
	name='company',
	size=6MB,
	filegrowth=1MB,
	maxsize=300MB,
	filename='E:\DATA\company.mdf'
),
filegroup groupl
(
	name='company1',
	filename='E\DATA\company1.ndf',
	size=6MB,
	filegrowth=1MB,
	maxsize=200MB
)
log on
(
	name='company_log',
	filename='E\DATA\company_log.ldf',
	size=6MB,
	filegrowth=1MB,
	maxsize=200MB
)
backup database company
to disk='D:Backup\company20210304.bak'
use master
restore database company
from disk='D:Backup\company20210304.bak'